datacontract export sql-query
Export a data contract to a SQL query.
datacontract export sql-query [OPTIONS] [LOCATION]
| Argument | Default | Description |
|---|---|---|
[LOCATION] | datacontract.yaml | The location (url or path) of the data contract yaml. |
| Option | Default | Description |
|---|---|---|
--dialect | auto | The SQL dialect. Use auto (default) to detect the SQL dialect via the specified servers in the data contract. |
--output | — | File path where the exported data will be saved. If not provided, it will be printed to stdout. |
--server | — | The server name to export. |
--schema-name | all | Which schema to export, e.g., orders, or all for all schemas (default). |
--json-schema | — | The location (url or path) of the ODCS JSON Schema. |
--inline-references / --no-inline-references | --inline-references | Resolve external references (currently: authoritativeDefinitions[type in {definition, semantics}]) in the contract and inline the fetched content from the configured entropy-data host. |
--debug / --no-debug | — | Enable debug logging |
datacontract export sql-query datacontract.yaml --dialect snowflake --output query.sql
Guide: Export: SQL Query.