Creating a Azure SQL source node - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating a Azure SQL source node

Prerequisites needed

  • A Amazon Glue Azure SQL connection, configured with an Amazon Secrets Manager secret, as described in the previous section, Creating a Azure SQL connection.

  • Appropriate permissions on your job to read the secret used by the connection.

  • A Azure SQL table you would like to read from, tableName.

    An Azure SQL table is identified by its database, schema and table name. You must provide the database name and table name when connecting to Azure SQL. You also must provide the schema if it is not the default, "public". Database is provided through a URL property in connectionName , schema and table name through the dbtable.

Adding a Azure SQL data source

To add a Data source – Azure SQL node:
  1. Choose the connection for your Azure SQL data source. Since you have created it, it should be available in the dropdown. If you need to create a connection, choose Create Azure SQL connection. For more information see the previous section, Creating a Azure SQL connection.

    Once you have chosen a connection, you can view the connection properties by clicking View properties.

  2. Choose a Azure SQL Source option:

    • Choose a single table – access all data from a single table.

    • Enter custom query – access a dataset from multiple tables based on your custom query.

  3. If you chose a single table, enter tableName.

    If you chose Enter custom query, enter a TransactSQL SELECT query.

  4. In Custom Azure SQL properties, enter parameters and values as needed.