As a first step create a small function in SQL Server to remove special characters from table name in SQL Server. Square brackets are not allowed in snowflake on Table names / column names.

If you work with data in SQL Server, you probably use functions to manipulate, transform, or aggregate values. But did you know that there are two types of functions in T-SQL: scalar and table-valued?