CSV to Databricks Delta DDL Generator

Generate a Databricks CREATE TABLE ... USING DELTA script and INSERT statements from a CSV, JSON, Excel or Parquet file. Free, runs in your browser.

Quick answer: Generate CREATE TABLE and INSERT statements from sample data.

Related: SQL INSERT Generator from CSV, JSON, Excel or Parquet · CSV to Snowflake CREATE TABLE Generator · CSV to BigQuery Schema and CREATE TABLE Generator · CSV to Redshift CREATE TABLE Generator · CSV Guides and Free CSV Tools

How to use the CSV to Databricks Delta DDL Generator

Generate CREATE TABLE and INSERT statements from sample data.

The SQL Generator turns a CSV, JSON, Excel or Parquet file into CREATE TABLE and INSERT statements for PostgreSQL, MySQL, SQL Server, Oracle or SQLite. It guesses a type for each column, lets you edit names, types, lengths and keys, and writes scripts you can run right away. It is useful for loading spreadsheets into a database and for building test fixtures.

  1. Load sample data
  2. Review the column types
  3. Pick a database and copy

Tips

Example

Input: id,name,age 1,Ada,36 2,Alan,41

Output: CREATE TABLE `people` ( `id` INT NOT NULL, `name` STRING ) USING DELTA;

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Why is there no primary key in the Delta DDL?

Delta primary keys only work with Unity Catalog, so they are left out to keep the script valid everywhere. NOT NULL is kept.

Does it connect to my database?

No. It only writes the SQL for you to run yourself.

Which databases does the SQL Generator support?

PostgreSQL, MySQL and MariaDB, SQL Server, Oracle and SQLite. It writes CREATE TABLE and INSERT statements from a CSV, JSON, Excel or Parquet file, and guesses column types from your data.

Related pages

Topic guides

Guides