Month: February 2025

SSRS Dynamic data source

We had a situation where a certain report needed to be accessed out of hours, when the report server was being refreshed. My solution was to include a drop-down list in the report called “Data Source”.

Then within the Data Source Properties I chose ‘build’ with a (temporary) static server name to get the login configured (which needs to be the same on both servers). Then amended the connection string by choosing ‘fx’ to construct something like this …

Note: Going forward, when working on reports with dynamic data sources I tend to change them back to ‘static’ and refresh the datasets before starting. Then put them back at the end.

Snowflake Glossary

Unload = Export

Data Warehouse = Snowflake is a cloud based data storage repository, optimised for analysis.

Warehouse = A virtual server. For CPU, memory, etc

Snowpark = Development libraries. Often used when building pipelines.

Snowsight = The Gui

Columnar = internal data storage method, where each data column has its own table.

Account = Typically, company membership credentials.

Schema = Catalogue of related items within a database.

Tag = Alias

Time travel = Retrieve ‘old’ data from up to 90 days ago.

Multi cluster = More than one warehouse linked to the same data.