Skip to main content
GET
/
api
/
code
/
v1
ListCode
curl --request GET \
  --url https://developer.synq.io/api/code/v1 \
  --header 'Authorization: Bearer <token>'
{
  "codes": [
    {
      "definerIdentifier": {
        "airflowDag": {
          "integrationId": "<string>",
          "dagId": "<string>"
        }
      },
      "stateAt": "2023-11-07T05:31:56Z",
      "definerSynqPath": "<string>",
      "definerEntityType": "ENTITY_TYPE_UNSPECIFIED",
      "codeType": "CODE_TYPE_UNSPECIFIED",
      "sqlDialect": "SQL_DIALECT_UNSPECIFIED",
      "content": "<string>",
      "codeName": "<string>",
      "filePath": "<string>"
    }
  ],
  "identifiers": [
    {
      "airflowDag": {
        "integrationId": "<string>",
        "dagId": "<string>"
      }
    }
  ],
  "synqPaths": [
    "<string>"
  ]
}

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

​
id.dbtCoreNode.integrationId
string<uuid>
required

SYNQ integration_id that identifies the dbt Core project

​
id.dbtCoreNode.nodeId
string
required

Dbt node_id that identifies one of dbt DAG nodes (model, test, etc)

​
id.dbtCloudNode.projectId
string
required

Your dbt Cloud project id

​
id.dbtCloudNode.accountId
string

Your dbt Cloud account id

​
id.dbtCloudNode.nodeId
string
required

Dbt node_id that identifies one of dbt DAG nodes (model, test, etc)

​
id.bigqueryTable.project
string
required

BigQuery project

​
id.bigqueryTable.dataset
string
required

BigQuery dataset id

​
id.bigqueryTable.table
string
required

BigQuery table name

​
id.snowflakeTable.account
string
required

Snowflake account

​
id.snowflakeTable.database
string
required

Snowflake database

​
id.snowflakeTable.schema
string
required

Snowflake schema

​
id.snowflakeTable.table
string
required

Snowflake table

​
id.redshiftTable.cluster
string

Redshift cluster

​
id.redshiftTable.database
string
required

Redshift database

​
id.redshiftTable.schema
string
required

Redshift schema

​
id.redshiftTable.table
string
required

Redshift table

​
id.postgresTable.host
string
required

Postgres hostname without port

​
id.postgresTable.database
string
required

Postgres database

​
id.postgresTable.schema
string
required

Postgres schema

​
id.postgresTable.table
string
required

Postgres table

​
id.mysqlTable.host
string
required

Mysql hostname without port

​
id.mysqlTable.schema
string
required

Mysql database

​
id.mysqlTable.table
string
required

Mysql table

​
id.clickhouseTable.host
string
required

Clickhouse hostname without port

​
id.clickhouseTable.schema
string
required

Clickhouse database

​
id.clickhouseTable.table
string
required

Clickhouse table

​
id.airflowDag.integrationId
string
required

SYNQ integration_id that identifies the Airflow instance

​
id.airflowDag.dagId
string
required

Airflow dag_id that identifies the DAG

​
id.airflowTask.integrationId
string
required

SYNQ integration_id that identifies the Airflow instance

​
id.airflowTask.dagId
string
required

Airflow dag_id that identifies the DAG

​
id.airflowTask.taskId
string
required

Airflow task_id that identifies the task within the DAG

​
id.custom.id
string
required

Id that identifies the custom entity The Id should be unique within the custom entity Identifier.

​
id.dataproduct.id
string<uuid>
required

Dataproduct id that identifies the Dataproduct

​
id.synqPath.path
string
required

SYNQ path that identifies the SYNQ entity, needs to be one of supported paths

​
id.databricksTable.workspace
string
required

URL of Databricks workspace

​
id.databricksTable.catalog
string
required

Databricks catalog

​
id.databricksTable.schema
string
required

Databricks schema

​
id.databricksTable.table
string
required

Databricks table or view

​
id.trinoTable.host
string
required

Hostname of the Trino instance

​
id.trinoTable.catalog
string
required

Trino catalog

​
id.trinoTable.schema
string
required

Trino schema

​
id.trinoTable.table
string
required

Trino table or view

​
id.sqlMeshModel.integrationId
string<uuid>
required

SYNQ integration_id that identifies the dbt Core project

​
id.sqlMeshModel.fqn
string
required

SQLMesh model fully qualified name

​
id.sqlMeshAudit.integrationId
string<uuid>
required

SYNQ integration_id that identifies the dbt Core project

​
id.sqlMeshAudit.fqn
string
required

SQLMesh model fully qualified name

​
id.sqlMeshAudit.auditId
string
required

Identifier of the audit

​
id.monitor.monitorId
string
required

Identifier of the monitor

​
id.monitor.segment
string

Optional monitor segmentation identifier

​
id.monitor.integrationId
string
deprecated

SYNQ integration_id of the monitored identifier

Response

200 - application/json

Success

ListCodeResponse is the response message for the ListCode method.

​
codes
Code · object[]

List of code artifacts associated with the requested entity. Each code artifact includes its content, type, and metadata about when it was captured.

​
identifiers
(airflow_dag · object | airflow_task · object | bigquery_table · object | clickhouse_table · object | custom · object | databricks_table · object | dataproduct · object | dbt_cloud_node · object | dbt_core_node · object | monitor · object | mysql_table · object | postgres_table · object | redshift_table · object | snowflake_table · object | sql_mesh_audit · object | sql_mesh_model · object | synq_path · object | trino_table · object)[]

Identifier is a unique reference to an entity in SYNQ system. Entity identifiers are designed to closely mimic identifiers used by data platforms and tools. To construct an identifier, you need to know the kind of the entity and the ids that you would normally use to identify it in the data platform or tool. For example, to identify a table in BigQuery, you would need to know the project, dataset, and table names.

​
synqPaths
string[]