Why Does My Query Return No Results When I Filter the LOG Table by connector_id?

Question

Why does my query return no results when I filter the LOG table using connector_id?

Environment

Fivetran Platform Connector

Answer

We have renamed the connector_id column to connection_id. Queries that filter on connector_id return no results because the LOG table no longer uses that column name. Update your query to use connection_id instead:

SELECT *
FROM FIVETRAN_LOG.LOG
WHERE CONNECTION_ID = '<your_connection_id>';