Skip to main content

datacontract export sql-query

Export a data contract to a SQL query.

datacontract export sql-query [OPTIONS] [LOCATION]
ArgumentDefaultDescription
[LOCATION]datacontract.yamlThe location (url or path) of the data contract yaml.
OptionDefaultDescription
--dialectautoThe SQL dialect. Use auto (default) to detect the SQL dialect via the specified servers in the data contract.
--outputFile path where the exported data will be saved. If not provided, it will be printed to stdout.
--serverThe server name to export.
--schema-nameallWhich schema to export, e.g., orders, or all for all schemas (default).
--json-schemaThe location (url or path) of the ODCS JSON Schema.
--inline-references / --no-inline-references--inline-referencesResolve external references (currently: authoritativeDefinitions[type in {definition, semantics}]) in the contract and inline the fetched content from the configured entropy-data host.
--debug / --no-debugEnable debug logging
datacontract export sql-query datacontract.yaml --dialect snowflake --output query.sql

Guide: Export: SQL Query.