Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

when setting up a connection with shortio, what is the primary key for clicks. there is no id column

The knowledge sources do not explicitly mention the primary key for the *Clicks* stream in the Short.io connector. The documentation for the Shortio connector lists the Clicks and Links streams but does not detail the primary key for the Clicks stream. [<https://docs.airbyte.com/integrations/sources/shortio|Shortio Connector>]

However, looking at the changelog, version *0.1.3* (2022-08-01) includes the note: _"Update primary key to `idString`"_ — suggesting that `idString` is the primary key used in the Shortio connector. [<https://docs.airbyte.com/integrations/sources/shortio#changelog|Shortio Changelog>]

It's possible this applies to the *Links* stream rather than Clicks specifically, but `idString` is the most likely candidate based on the available information. For a definitive answer, I'd recommend checking the <https://github.com/airbytehq/airbyte/tree/master/airbyte-integrations/connectors/source-shortio|Shortio connector source on GitHub> or reaching out to the Airbyte community. :thumbsup: 0 button :thumbsdown: 0 button :information_source: *Tip:* Mention *@kapa.ai* in the thread for follow-ups or *DM the app* for *1-to-1* help.