sql_pool_columns

Creates, updates, deletes, gets or lists a sql_pool_columns resource.

Overview

Name	sql_pool_columns
Type	Resource
Id	azure.synapse.sql_pool_columns

Fields

vw_sql_pool_columns

Name	Datatype	Description
columnName	text	field from the properties object
column_type	text	field from the properties object
is_computed	text	field from the properties object
resourceGroupName	text	field from the properties object
schemaName	text	field from the properties object
sqlPoolName	text	field from the properties object
subscriptionId	text	field from the properties object
tableName	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_columns

Name	Datatype	Description
properties	object	Sql pool column properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	columnName, resourceGroupName, schemaName, sqlPoolName, subscriptionId, tableName, workspaceName	Get Sql pool column

SELECT examples

Get Sql pool column

vw_sql_pool_columns

SELECT
columnName,
column_type,
is_computed,
resourceGroupName,
schemaName,
sqlPoolName,
subscriptionId,
tableName,
workspaceName
FROM azure.synapse.vw_sql_pool_columns
WHERE columnName = '{{ columnName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND schemaName = '{{ schemaName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND tableName = '{{ tableName }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_columns

SELECT
properties
FROM azure.synapse.sql_pool_columns
WHERE columnName = '{{ columnName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND schemaName = '{{ schemaName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND tableName = '{{ tableName }}'
AND workspaceName = '{{ workspaceName }}';