This post serves as a quick set of instructions to import a CSV into a table in the Microsoft Azure Databricks environment.
Prerequisites
- Setup a paid or free trail. See how we setup the free trial using Microsoft Azure.
- CSV data you want to query.
Import your CSV file
Drag your file in, set up the table names and properties of your csv
setup the column names and check it looks ok
Update any of the details you feel relevant. Notice that it now gives you an AI Generated table comment suggestion that you can keep, edit or put your own in there.
and also at the column level
I do have a love/hate with these helpers. On one hand it’s really great that it helps you populate information about your tables and is great when you’re doing a POC or messing about but sometimes I prefer these to be blank to force people to put something more meaningful in. What are your experiences with using autogen for table and column names?
Once you’re happy you can create the blue Create (and choose query) to start using your table