Troubleshooting the Snowflake Connector for PostgreSQL¶
Note
The Snowflake Connector for PostgreSQL is subject to the Connector Terms.
Issues¶
This section contains tips to resolve and troubleshoot issues related to Snowflake Connector for PostgreSQL. If your issue is not listed here, see Contact Snowflake Support.
Ingestion¶
If you suspect that the ingestion process is stuck for a long time, you can run a stored procedure that attempts to repair the connector. To initiate a repair process, run the following command:
CALL PUBLIC.REPAIR_CONNECTOR();Note
The procedure does not solve all problems with the connector. It is safe to run the procedure multiple times.
Contact Snowflake Support¶
If you encounter any issues while using the connector, submit a support case. When submitting a support case, we recommend that you share the logs for a quicker resolution. This is because Snowflake distributes the connector through the Native App Framework and metric data is not automatically returned to Snowflake.
The connector uses two types of log streams:
Native App logs collected by the native application.
Logs collected by the database agent, which runs in your infrastructure.