AzureSqlDatabaseOutputDataSource Class

Describes an Azure SQL database output data source.

All required parameters must be populated in order to send to Azure.

Inheritance

azure.mgmt.streamanalytics.models._models_py3.OutputDataSource

AzureSqlDatabaseOutputDataSource

Constructor

AzureSqlDatabaseOutputDataSource(*, server: Optional[str] = None, database: Optional[str] = None, user: Optional[str] = None, password: Optional[str] = None, table: Optional[str] = None, max_batch_count: Optional[float] = None, max_writer_count: Optional[float] = None, authentication_mode: Optional[Union[str, azure.mgmt.streamanalytics.models._stream_analytics_management_client_enums.AuthenticationMode]] = None, **kwargs)

Parameters

type

str

Required

Required. Indicates the type of data source output will be written to. Required on PUT (CreateOrReplace) requests.Constant filled by server.

server

str

Required

The name of the SQL server containing the Azure SQL database. Required on PUT (CreateOrReplace) requests.

database

str

Required

The name of the Azure SQL database. Required on PUT (CreateOrReplace) requests.

user

str

Required

The user name that will be used to connect to the Azure SQL database. Required on PUT (CreateOrReplace) requests.

password

str

Required

The password that will be used to connect to the Azure SQL database. Required on PUT (CreateOrReplace) requests.

table

str

Required

The name of the table in the Azure SQL database. Required on PUT (CreateOrReplace) requests.

max_batch_count

float

Required

Max Batch count for write to Sql database, the default value is 10,000. Optional on PUT requests.

max_writer_count

float

Required

Max Write r count, currently only 1(single writer) and 0(based on query partition) are available. Optional on PUT requests.

authentication_mode

str or <xref:stream_analytics_management_client.models.AuthenticationMode>

Required

Authentication Mode. Possible values include: "Msi", "UserToken", "ConnectionString".