names are case-insensitive (so using lowercase throughout is fine).
maximum number of characters in a table name: 260.
all object names must begin with a letter, number, or underscore (_).
the following characters are not allowed: . + ? / < > * % & : \
| category | abbreviation | linked service prefix | dataset prefix |
|---|---|---|---|
| azure blob storage | abls | ls_abls |
ds_abls |
| azure data lake storage gen1 | adls1 | ls_adls1 |
ds_adls1 |
| azure data lake storage gen2 | adls2 | ls_adls2 |
ds_adls2 |
| azure sql database | asql | ls_asql |
ds_asql |
| azure sql managed instance | asmi | ls_asmi |
ds_asmi |
| azure synapse dedicated sql pool | asdw | ls_asdw |
ds_asdw |
| azure synapse serverless sql | assql | ls_assql |
ds_assql |
| azure synapse workspace (generic) | asyn | ls_asyn |
ds_asyn |
| azure file storage | afil | ls_afil |
ds_afil |
| azure table storage | atbl | ls_atbl |
ds_atbl |
| azure cosmos db (sql api) | acsa | ls_acsa |
ds_acsa |
| azure cosmos db (mongodb api) | acma | ls_acma |
ds_acma |
| azure mysql | amys | ls_amys |
ds_amys |
| azure postgresql | apos | ls_apos |
ds_apos |
| azure flexible mysql | afmys | ls_afmys |
ds_afmys |
| azure flexible postgresql | afpos | ls_afpos |
ds_afpos |
| azure data explorer (kusto) | adex | ls_adex |
ds_adex |
| azure key vault | akv | ls_akv |
ds_akv |
| azure event hub | aevh | ls_aevh |
ds_aevh |
| azure service bus | asb | ls_asb |
ds_asb |
| azure synapse spark | aspk | ls_aspk |
ds_aspk |
| sql server on-premises | sql | ls_sql |
ds_sql |
| oracle database | ora | ls_ora |
ds_ora |
| mysql (generic) | mys | ls_mys |
ds_mys |
| postgresql (generic) | pos | ls_pos |
ds_pos |
| db2 | db2 | ls_db2 |
ds_db2 |
| teradata | tda | ls_tda |
ds_tda |
| snowflake | snf | ls_snf |
ds_snf |
| redshift | rsh | ls_rsh |
ds_rsh |
| bigquery | bgq | ls_bgq |
ds_bgq |
| sap ecc | sap | ls_sap |
ds_sap |
| sap hana | hana | ls_hana |
ds_hana |
| sap bw | sapbw | ls_sapbw |
ds_sapbw |
| amazon s3 | s3 | ls_s3 |
ds_s3 |
| amazon rds mysql | armys | ls_armys |
ds_armys |
| amazon rds postgres | arpos | ls_arpos |
ds_arpos |
| oracle cloud storage | ocs | ls_ocs |
ds_ocs |
| ftp | ftp | ls_ftp |
ds_ftp |
| sftp | sftp | ls_sftp |
ds_sftp |
| http | http | ls_http |
ds_http |
| rest api | rest | ls_rest |
ds_rest |
| web table / odata | odta | ls_odta |
ds_odta |
| sharepoint online | spo | ls_spo |
ds_spo |
| dynamics 365 | d365 | ls_d365 |
ds_d365 |
| salesforce | sfc | ls_sfc |
ds_sfc |
| workday | wday | ls_wday |
ds_wday |
| service now | snow | ls_snow |
ds_snow |
| marketo | mkt | ls_mkt |
ds_mkt |
| hive | hive | ls_hive |
ds_hive |
| hdfs | hdfs | ls_hdfs |
ds_hdfs |
| generic file system | fs | ls_fs |
ds_fs |
| generic odbc | odbc | ls_odbc |
ds_odbc |
| generic jdbc | jdbc | ls_jdbc |
ds_jdbc |
| power bi / fabric lakehouse | lake | ls_lake |
ds_lake |
| fabric warehouse | fwh | ls_fwh |
ds_fwh |
| fabric kql database | fkql | ls_fkql |
ds_fkql |
| generic no-op / dummy | nul | ls_nul |
ds_nul |
Source: https://erwindekreuk.com/2020/07/azure-data-factory-naming-conventions/