Showing results for 
Search instead for 
Did you mean: 

Force create table to a DATE datatype (BigQuery) when first value of pipe is empty string or null.

New Contributor

Running into an issue I can't solve.

I'm unable to have Snap create a table (if not present) with a DATE datatype field (instead of a string datatype) if the first import row encountered is a null or empty date string.  That is, I want the newly created table's field to be of type DATE and the data to be null. I do not want type a string datatype field with value "" or null. Also, I'm using the BiqQuery Write snap for this.

Is this possible?

The obvious issue is, depending on first value encountered, the data type of the newly created table can become either a string or date. This is not good when, I'd like them all to be date (filled with null if empty strings) for all cases.