Insert NULL in Google Cloud SQL using CSV import

Question

I am importing CSV files into Google Cloud SQL using its import functionality. It allows to import data into a Cloud SQL table.

If I use a CSV row with empty values, like:

,,,,42,,

I am getting 0 values in the SQL table. I would like to get NULL values instead. Is it possible ?

Actually, my question applies to several languages and can be replicated using Google Cloud UI alone. So, is a code snippet going to be helpful ? — JoseKilo
– JoseKilo, Commented Jan 10, 2017 at 11:37
Hi @JoseKilo, did you manage to solve this? Any 2018 updates? — Ary Jazz
– Ary Jazz, Commented Sep 6, 2018 at 12:01
Not really. It's been a while. I think I ended up changing the way I generated my CSVs. Sorry. I would try something like this (I think this functionality is/was based on MySQL LOAD DATA) stackoverflow.com/a/2675493/2452074 But I think I already tried that back in the day. — JoseKilo
– JoseKilo, Commented Sep 6, 2018 at 15:07
Update from 2022 and using postgres w/ CloudSQL. Empty columns are interpreted as null. E.g. "id",,"some val" would be copied as ["id", NULL, "some val"] — Daniel
– Daniel, Commented Aug 25, 2022 at 2:05

sonium · Accepted Answer · 2022-02-05 12:06:51Z

0

I found it to work using NULL as a field value:

"gid://Customer/10031988754",0,0,"GBP","[]","GB"
"gid://Customer/1003793973310",0,NULL,NULL,"[]","GB"

this was unexpected, since CSV export generates entries with "N as NULL

answered Feb 5, 2022 at 12:06

sonium

1,1001 gold badge13 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1