Is there documentation on SQL Queries?

Hi,

I’m just getting started with Cognite. I’m trying to create some assets. I’ve loaded them into RAW and I’m trying to write a SQL transformation to load them into assets. Is there documentation on what functions are available? I’ve gone through the online training and the simple example there, but it doesn’t cover what I’m trying to do.

My specific questions are that I’m looking for documentation to answer are (for now):

1. What data type is the id, parentid, and other fields
2. How do I cast the string data in the csv to right type. I assume there is a Cast function
   1. The UI tells me I have the wrong type. It doesn’t tell me which field and what type it expects. That would really be helpful. In this case, I know what field, but I don’t know the type it’s looking for.
3. For a top level asset in the hierarchy, what do I use for parentID?
4. If I have spaces in the field names in my CSV, how can I reference the field?