Skip to main content

datacontract export sql

Export a data contract to SQL DDL.

datacontract export sql [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.
--clickhouse-engineThe ClickHouse table engine. Default: MergeTree(). Example: ReplicatedMergeTree('/clickhouse/tables/{shard}/table', '{replica}')
--clickhouse-order-byORDER BY columns for ClickHouse (comma-separated). ClickHouse uses ORDER BY as its primary/sorting key (not PRIMARY KEY). Default: primary key columns if defined, omitted otherwise. Example: --clickhouse-order-by "event_date DESC, event_id"
--debug / --no-debugEnable debug logging
datacontract export sql datacontract.yaml --dialect postgres --output ddl.sql

Guide: Export: SQL DDL.