AzureSqlReferenceInputDataSourceProperties Class

AzureSqlReferenceInputDataSourceProperties.

Inheritance

Model

AzureSqlReferenceInputDataSourceProperties

Constructor

AzureSqlReferenceInputDataSourceProperties(*, server: Optional[str] = None, database: Optional[str] = None, user: Optional[str] = None, password: Optional[str] = None, table: Optional[str] = None, refresh_type: Optional[str] = None, refresh_rate: Optional[str] = None, full_snapshot_query: Optional[str] = None, delta_snapshot_query: Optional[str] = None, **kwargs)

Parameters

server

str

Required

This element is associated with the datasource element. This is the name of the server that contains the database that will be written to.

database

str

Required

This element is associated with the datasource element. This is the name of the database that output will be written to.

user

str

Required

This element is associated with the datasource element. This is the user name that will be used to connect to the SQL Database instance.

password

str

Required

This element is associated with the datasource element. This is the password that will be used to connect to the SQL Database instance.

table

str

Required

This element is associated with the datasource element. The name of the table in the Azure SQL database..

refresh_type

str

Required

This element is associated with the datasource element. This element is of enum type. It indicates what kind of data refresh option do we want to use:Static/RefreshPeriodicallyWithFull/RefreshPeriodicallyWithDelta.

refresh_rate

str

Required

This element is associated with the datasource element. This indicates how frequently the data will be fetched from the database. It is of DateTime format.

full_snapshot_query

str

Required

This element is associated with the datasource element. This query is used to fetch data from the sql database.

delta_snapshot_query

str

Required

This element is associated with the datasource element. This query is used to fetch incremental changes from the SQL database. To use this option, we recommend using temporal tables in Azure SQL Database.