warnings

Creates, updates, deletes, gets or lists a warnings resource.

Overview

Name	warnings
Type	Resource
Id	fivetran.connections.warnings

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
schema	string	The destination schema name. Omitted for warnings that are not scoped to a specific table. (example: my_schema)
table	string	The destination table name. Omitted for warnings that are not scoped to a specific table. (example: my_table)
warnings	array	List of warnings for this table

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	connection_id		Retrieve all active warnings for a connection, grouped by destination table. Each warning includes a code, message, error details, and creation timestamp.
dismiss	delete	connection_id, warning_type		Dismiss all active warnings of a specific type for a connection. Requires the warning type to be registered in the warning type registry.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
connection_id	string	The unique identifier of the connection. Retrieve it from the id field in the [List All Connections](https:​//fivetran.com/docs/rest-api/api-reference/connections/list-connections) response, or from the id field returned when you [Create a Connection](https:​//fivetran.com/docs/rest-api/api-reference/connections/create-connection).
warning_type	string	The warning type to dismiss (e.g., 'resync_table_warning', 'type_coercion_to_null_warning')

SELECT examples

list

Retrieve all active warnings for a connection, grouped by destination table. Each warning includes a code, message, error details, and creation timestamp.

SELECT
"schema",
table,
warnings
FROM fivetran.connections.warnings
WHERE connection_id = '{{ connection_id }}' -- required
;

DELETE examples

dismiss

Dismiss all active warnings of a specific type for a connection. Requires the warning type to be registered in the warning type registry.

DELETE FROM fivetran.connections.warnings
WHERE connection_id = '{{ connection_id }}' --required
AND warning_type = '{{ warning_type }}' --required
;