Importing a CSV into Microsoft Azure Databricks

posted in: Databricks | 0

This post serves as a quick set of instructions to import a CSV into a table in the Microsoft Azure Databricks environment.

Prerequisites

Import your CSV file

image

Drag your file in, set up the table names and properties of your csv

image

setup the column names and check it looks ok

image

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.

image

and also at the column level

image

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

image