Load data with SQL with Code Assist

This example shows how to load data using custom SQL and demonstrates the auto complete feature of the SQL editor.

SQL & Redshift

  1. Click the Domino Code Assist button in the toolbar. It inserts a code snippet in a new code cell and execute it.

  2. Once Code Assist initializes, if you hover over the assistant icon icon, a popup menu appears. Select the Load Data item from the menu.

  3. Select Redshift from the drop-down list of data sources.

  4. Choose the database and schema, then toggle on Use query.

    Specify a database and schema then toggle Use query
  5. Type the query into the Query box. For example:

    select listid, eventname, venuename, venuecity, priceperticket, numtickets
    from listing
    inner join event
    on
        listing.eventid = event.eventid
    inner join venue
    on
        event.venueid = venue.venueid
    where
        venuecity = 'New York City';
  6. Click the INSERT CODE button.

Code Assist inserts code into the next cell and immediately executes it.

Code is inserted and executed

SQL & Snowflake

  1. Select Snowflake from the drop-down list of data sources.

  2. Choose the database and schema, then toggle on Use query.

  3. Type the query into the Query box. For example:

    select CC_CALL_CENTER_ID, CC_NAME, CC_EMPLOYEES, CC_SQ_FT
    from SNOWFLAKE_SAMPLE_DATA.TPCDS_SF10TCL.CALL_CENTER
    where CC_EMPLOYEES > 600000000;

    Code Assist inserts code into the next cell and immediately executes it.

Code is inserted and executed