Handling null values in connector test data for Snowflake schema

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

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


Question

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"]
2

New message text here

3

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

4

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"]

5

Okay I’ll give that a try, thank you