Handling null values in connector test data for Snowflake schema


When building a connector, ensuring that null values in test data are correctly mapped to Snowflake schema


When building a connector, if the test data that comes through is showing null for some fields but the actual data has values for some of them, how do I make sure this comes through and gets into snowflake and applied to the schema?

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["handling-null-values", "connector", "snowflake", "test-data", "schema"]

New message text here

What about in the low-code UI builder for building custom connectors?

You can open the Declared Schema tab on your stream, disable Automatically import detected schema, and modify the type of the field to your desired type, e.g. type: ["null", "string"]

Okay I’ll give that a try, thank you