Ingest a Parquet file with BULK INSERT

This example demonstrates how to:

Create a FeatureBase table with a required structure
Copy and transform data from an parquet source
Use the BULK INSERT statement to copy data from the source to the target table.

Before you begin

BULK INSERT statement

Cloud users:

Community users:

Learn how to create tables

Step 1: create table

CREATE TABLE sample (
    _id id,
    x int,
    y decimal(4)
);

Step 2: ingest data

BULK INSERT
      INTO sample(_id,x,y )
      MAP(
    'id' id,
    'intval' int,
    'decval' decimal(4) )
 FROM
	'https://s3.amazonaws.com/todd-scratch.molecula.com/sample.parquet'
 WITH 
    FORMAT 'PARQUET'
    INPUT 'URL';

Step 3: query the data

SELECT TOP(10) * FROM sample;

Further information