Transfer data from a private Azure Blob Storage container to Teradata

To transfer data from a private Azure Blob Storage container to Teradata, complete the following prerequisites:

• Create an Azure account.
• Create an Azure storage account.
• Create a blob container in the Azure storage account.
• Upload CSV, JSON, or Parquet files to the blob container.

• Create a Teradata authorization object using the Azure storage account name and access key.

  CREATE AUTHORIZATION azure_authorization
  USER 'azuretestquickstart'
  PASSWORD 'AZURE_BLOB_ACCOUNT_ACCESS_KEY';
  

  Note

  Replace azuretestquickstart with the Azure storage account name and AZURE_BLOB_ACCOUNT_ACCESS_KEY with its access key.

• In the transfer_data_csv task, replace YOUR-PRIVATE-OBJECT-STORE-URI with the URI of the private container and add the teradata_authorization_name parameter with the Teradata authorization object name.

  transfer_data_csv = AzureBlobStorageToTeradataOperator(
      task_id="transfer_data_blob_to_teradata_csv",
      blob_source_key="YOUR-PRIVATE-OBJECT-STORE-URI",
      teradata_table="example_blob_teradata_csv",
      teradata_conn_id="teradata_default",
      teradata_authorization_name="azure_authorization",
      trigger_rule="always",
  )