ADF Naming Convention

Azure      
  Abbreviation Linked Service Dataset
Azure Blob Storage ABLB_ LS_ABLB_ DS_ABLB_
Azure Cosmos DB SQL API ACSA_ LS_ACSA_ DS_ACSA_
Azure Cosmos DB MongDB API ACMA_ LS_ACMA_ DS_ACMA_
Azure Data Explorer ADEX_ LS_ADEX_ DS_ADEX_
Azure Data Lake Storage Gen1 ADLS_ LS_ADLS_ DS_ADLS_
Azure Data Lake Storage Gen2 ADLS_ LS_ADLS_ DS_ADLS_
Azure Database for MariaDB AMDB_ LS_AMDB_ DS_AMDB_
Azure Database for MySQL AMYS_ LS_AMYS_ DS_AMYS_
Azure Database for PostgreSQL APOS_ LS_APOS_ DS_APOS_
Azure File Storage AFIL_ LS_AFIL_ DS_AFIL_
Azure Search ASER_ LS_ASER_ DS_ASER_
Azure SQL Database ASQL_ LS_ASQL_ DS_ASQL_
Azure SQL Database Managed Instance ASQM_ LS_ASQM_ DS_ASQM_
Azure SQL Data Warehouse ASDW_ LS_ASDW_ DS_ASDW_
Azure Table Storage ATBL_ LS_ATBL_ DS_ATBL_
       
Database      
  Abbreviation Linked Service Dataset
SQL Server  MSQL_ LS_SQL_ DS_SQL_
Oracle ORAC_ LS_ORAC_ DS_ORAC_
MySQL MYSQ_ LS_MYSQ_ DS_MYSQ_
DB2 DB2_ LS_DB2_ DS_DB2_
Teradata  TDAT_ LS_TDAT_ DS_TDAT_
PostgreSQL POST_ LS_POST_ DS_POST_
Sybase SYBA_ LS_SYBA_ DS_SYBA_
Cassandra CASS_ LS_CASS_ DS_CASS_
MongoDB MONG_ LS_MONG_ DS_MONG_
Amazon Redshift ARED_ LS_ARED_ DS_ARED_
SAP Business Warehouse SAPW_ LS_SAPW_ DS_SAPW_
SAP HANA HANA_ LS_HANA_ DS_HANA_
       
Files      
  Abbreviation Linked Service Dataset
File System FILE_ LS_FILE_ DS_FILE_
HDFS HDFS_ LS_HDFS_ DS_HDFS_
Amazon S3  AMS3_ LS_AMS3_ DS_AMS3_
FTP FTP_ LS_FTP_ DS_FTP_
SFTP SFTP_ LS_SFTP_ DS_SFTP_
       
Divers      
  Abbreviation Linked Service Dataset
Salesforce SAFC_ LS_SAFC_ DS_SAFC_
Generic ODBC ODBC_ LS_ODBC_ DS_ODBC_
Generic OData  ODAT_ LS_ODAT_ DS_ODAT_
Web Table (table from HTML)  WEBT_ LS_WEBT_ DS_WEBT_
REST REST_ LS_REST_ DS_REST_
HTTP HTTP_ LS_HTTP_ DS_HTTP_
       
Type Name Action Example
Data movement Activity PL_DATA_ NA PL_DATA_DS_SQL_Person_To_DS_ABLB_Person
Data transformation pipeline PL_TRAN_ SPRC – Stored Procedure PL_TRAN_SPRC_CleanDimAccount
  PL_TRAN_ DNET – Script PL_TRAN_DNET_AggregateSales
  PL_TRAN_ ADLK – Azure Data Lake PL_TRAN_ADLK_AggregateSales
  PL_TRAN_ HIVE – Hive PL_TRAN_HIVE_AggregateSales
  PL_TRAN_ PIG – Pig PL_TRAN_PIG_AggregateSales
  PL_TRAN_ MAPR – MapReduce PL_TRAN_MAPR_AggregateSales
  PL_TRAN_ HADP – Hadoop Stream PL_TRAN_HADP_StreamData
  PL_TRAN_ AML – Azure Machine Learning PL_TRAN_AML_CalculateMonthlyChurn
       
Activities      
Move & Transform Copy Data ACT_MT_Copy_ ACT_MT_Copy_FunctionalPurpose
  Data FloW ACT_MT_DF ACT_MT_DF_FunctionalPurpose
General Append Variable ACT_GEN_APPVAR ACT_GEN_APPVAR_FunctionalPurpose
  Delete ACT_GEN_DEL ACT_GEN_DEL_FunctionalPurpose
  Execute Pipeline ACT_GEN_EPIPE ACT_GEN_EPIPE_FunctionalPurpose
  Execute SSIS ACT_GEN_ESSIS ACT_GEN_ESSIS_FunctionalPurpose
  Get Metadata ACT_GEN_META ACT_GEN_META_FunctionalPurpose
  Lookup ACT_GEN_LKP ACT_GEN_LKP_FunctionalPurpose
  Stored Procedure ACT_GEN_SPRC ACT_GEN_SPRC_FunctionalPurpose
  Set Variable ACT_GEN_SETVAR ACT_GEN_SETVAR_FunctionalPurpose
  Validation ACT_GEN_VALID ACT_GEN_VALID_FunctionalPurpose
  Web ACT_GEN_WEB ACT_GEN_WEB_FunctionalPurpose
  WebHook ACT_GEN_WHOOK ACT_GEN_WHOOK_FunctionalPurpose
  Wait ACT_GEN_WAIT ACT_GEN_WAIT_FunctionalPurpose
Iteration & conditionals Filter ACT_ITRC_FIL ACT_ITRC_FIL_FunctionalPurpose
  For Each ACT_ITRC_FOR ACT_ITRC_FOR_FunctionalPurpose
  If Condition ACT_ITRC_IF ACT_ITRC_IF_FunctionalPurpose
  Switch ACT_ITRC_SWITCH ACT_ITRC_SWITCH_FunctionalPurpose
  Until ACT_ITRC_UNTILL ACT_ITRC_UNTILL_FunctionalPurpose
Data Bricks Notebook ACT_ADB_NOTE ACT_ADB_NOTE_FunctionalPurpose
  Jar ACT_ADB_JAR ACT_ADB_JAR_FunctionalPurpose
  Python ACT_ADB_PY ACT_ADB_PY_FunctionalPurpose
Batch Service Custom ACT_BAT_CUST ACT_BAT_CUST_FunctionalPurpose
Data Lake Analytics U-SQL ACT_ADLA_CUST ACT_ADLA_CUST_FunctionalPurpose
Azure Function Azure Function ACT_AF_AF ACT_AF_AF_FunctionalPurpose
HDInsight Hive ACT_HDI_HIVE ACT_HDI_HIVE_FunctionalPurpose
  Map Reduce ACT_HDI_MAPR ACT_HDI_MAPR_FunctionalPurpose
  Pig ACT_HDI_PIG ACT_HDI_PIG_FunctionalPurpose
  Spark ACT_HDI_SPARK ACT_HDI_SPARK_FunctionalPurpose
  Streaming ACT_HDI_STREAM ACT_HDI_STREAM_FunctionalPurpose
Machine Learning ML Batch execution ACT_ML_BATCH ACT_ML_BATCH_FunctionalPurpose
  ML Update Resource ACT_ML_UPD ACT_ML_UPD_FunctionalPurpose
  ML Execute Pipeline ACT_ML_EPIPE ACT_ML_EPIPE_FunctionalPurpose

 

Azure Data Factory Naming Conventions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s