Archives: FAQs

Q: What role does an HTTP interceptor play in SPA authentication?

 A: An HTTP interceptor can catch all outgoing HTTP requests and automatically add authorization headers (e.g. Bearer tokens) so that you don’t have to manually set headers everywhere in your code. It centralizes token handling and helps avoid repetition.

Q: What is an Auth Guard in Angular, and when should I use it?

A:  Auth Guards are Angular services that implement interfaces like CanActivate, CanActivateChild, CanLoad, etc. They let you protect routes (including lazy-loaded modules) by checking authentication before allowing navigation. Use them wherever you want to restrict access to certain pages/components based on login status.

Q: What metadata does the Snowflake stream provide, and how is it useful?

Streams provide things like: METADATA$ACTION (whether a change was an insert, delete, etc.) METADATA$ROWID (to identify rows across changes) METADATA$ISUPDATE flag or similar to check if the changed row is an update vs just a change in value. This metadata helps in merging efficiently into downstream tables and applying logic depending on type of change.

Q: How do I set up a basic CDC workflow in Snowflake?

 A: The blog outlines: Create a source (OLTP) table Use Python (and libraries like snowflake-connector-python, sqlalchemy, pandas) to load data into Snowflake Create a Snowflake Stream object on that table to capture changes (captures metadata such as METADATA$ACTION, METADATA$ROWID, etc.) Use a SQL MERGE into a final target table to apply inserts/updates/deletes based on captured […]

Back To Top