how can I find which "secrets" (stored on the secret table) are used on my source?

Based on the provided knowledge sources, I can offer some information about secrets in Airbyte, but there isn't a direct method described to find which specific secrets are used by a particular source. However, I can provide some relevant details about how Airbyte handles secrets: 1. Airbyte stores secrets in a configured secret persistence layer as Sources and Destinations are created [Understanding Airbyte Secrets](https://docs.airbyte.com/understanding-airbyte/secrets). 2. For open-source versions of Airbyte that haven't set up an external secrets store, secrets are stored in a table called

secrets

in the config database [Airbyte Databases Data Catalog](https://docs.airbyte.com/understanding-airbyte/database-data-catalog#config-database). 3. Secrets are associated with workspaces. Each secret coordinate (the identifier for a secret) contains the workspace ID, which allows operators to understand what workspace a secret belongs to [Operational Details](https://docs.airbyte.com/understanding-airbyte/secrets#operational-details). 4. When configuration is updated, Airbyte increments a secret coordinate's version while preserving the prefix. This means you can potentially track changes to secrets over time [Operational Details](https://docs.airbyte.com/understanding-airbyte/secrets#operational-details). 5. It's important to note that Airbyte aims to keep secrets secure by not exposing them directly. The documentation states that secrets "must not be returned by the api" and "must not be printed in logs" [Understanding Airbyte Secrets](https://docs.airbyte.com/understanding-airbyte/secrets). Given this information, while you can't directly query which secrets are used by a specific source, you might be able to infer some information based on the workspace ID and the naming conventions of the secret coordinates. However, for security reasons, Airbyte intentionally limits direct access to secret information. If you need more specific information about secrets used by your sources, you might need to consult with your Airbyte administrator or refer to your source configurations, keeping in mind that the actual secret values should not be exposed.

@kapa.ai found it the secret the source references can be found on the actor.config table

I apologize, but I don't have enough context to fully understand or confirm your statement. However, I can provide some relevant information about Airbyte's database structure based on the knowledge sources provided: Airbyte uses a database called

airbyte-db

to store various configuration and operational data. The

actor

table in this database is indeed one of the important tables that stores information about source and destination connectors. According to the [Understanding the core components:

airbyte-db

> Databases and Tables](https://github.com/airbytehq/airbyte/discussions/33809) discussion, the

actor

table is part of the

configs

database schema. If you're trying to access or query this table, you can do so by connecting to the Airbyte database. The default method to access the database is described in the [Accessing the default database located in docker airbyte-db](https://docs.airbyte.com/operator-guides/configuring-airbyte-db#accessing-the-default-database-located-in-docker-airbyte-db) documentation:

docker exec -ti airbyte-db psql -U docker -d airbyte

Once connected, you could query the

actor

table to find the configuration information you're looking for. However, please note that accessing and modifying database contents directly should be done with caution, as it might affect the functioning of your Airbyte instance. If you're looking for specific information about secrets or configurations for a particular source, it might be more appropriate to use Airbyte's user interface or API to manage these settings. The exact location and format of secrets can vary depending on the specific source connector you're using.