Describe the bug I have some column names with spaces in them. I use {{ dbt_utils.generate_surrogate_key( ["column with spaces"] ) }} as id, which compiles to ...

The SQL Exporter should, by default, convert column names to an SQL-compliant name, replacing spaces and other illegal characters with "_" (underscore). Column names can also not begin with numbers.

To calculate the average of a column using SQL, you can use the AVG() function. Here's an example of how you can do it: ```sql SELECT AVG(column_name) AS average_value FROM table_name; ``` Replace ...

Some DBMSs allow case sensitive column and table names as well as names with special characters such as an Oracle column named Amount Budgeted$. Therefore, special consideration should be used when ...