CLI Reference

tables

Print how each Kafka topic maps to a Snowflake table, stream and consumer group, without connecting to Snowflake.

sqlload tables [--topics-file FILE]

sqlload tables shows how the Kafka exporter names each topic’s table, stream and consumer group, before anything connects to Snowflake. It prints one line per topic:

<topic>  <table>  <stream>  <consumer group>

separated by tabs. A topic a naming rule skips (skip = true) prints - after its name. Topics that include doesn’t match, or exclude does, aren’t listed.

Option	Meaning
`--topics-file <FILE>`	Read topic names, one per line, from this file instead of listing them in Kafka.

With the repository’s sqlload.example.toml and a file of topic names:

$ sqlload tables --topics-file topics.txt
shop.legacy-orders  ORDERS_V1  orders_v1  sqlload-orders_v1
shop.orders_v2.events  ORDERS__EVENTS  orders__events  sqlload-orders__events
shop.payments_v1.events  PAYMENTS__EVENTS  payments__events  sqlload-payments__events

shop.orders.dlq was in the file too, but matches the example’s exclude, so it isn’t listed. Kafka topic naming covers the rules.

Part of SQLStack