<@U04S8PLJWMT> is there a table in the airbyte-db ...
# replication-ask-ai
n
@kapa.ai is there a table in the airbyte-db that can tell me the names of all tables synced in a particular connection
k
The knowledge sources do not contain enough information to answer your query about querying the
airbyte-db
internal database directly to find table names synced for a particular connection. However, there are a couple of approaches mentioned in the documentation that may help you find stream/table names: Using PyAirbyte (for Airbyte Cloud with SQL-based destinations): If you're using Airbyte Cloud with a supported SQL-based destination (like Snowflake or BigQuery), you can use PyAirbyte to retrieve stream names programmatically:
Copy code
from airbyte import cloud

workspace = cloud.CloudWorkspace(
    workspace_id="123",
    api_key=ab.get_secret("AIRBYTE_CLOUD_API_KEY"),
)

connection = workspace.get_connection(connection_id="456")
sync_result = connection.get_sync_result()

# Print a list of available stream names
print(sync_result.stream_names)
[PyAirbyte sync results] Via the Airbyte UI: You can also view which streams are enabled for a connection by navigating to Connections → [your connection] → Schema tab in the Airbyte UI. [Configuring schemas] For directly querying the internal
airbyte-db
database, I'd recommend checking the Airbyte documentation or community forums, as the knowledge sources available to me don't cover that internal database schema. 👍 0 button 👎 0 button â„šī¸ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.