search

fullstorydev / hauser

Service for moving your Fullstory export files to a data warehouse
MIT License
49 stars 23 forks source link

Patrick/custom redshift schemas #43

Closed patrick-fs closed 5 years ago

patrick-fs commented 5 years ago

Happy Holidays! I hope you and yours are well.

This PR will allow customer-defined schemas to be used when integrating with Redshift: https://github.com/fullstorydev/hauser/issues/35

I've smoke-tested for the "public" schema, "search_path," and an arbitrary schema I created called "patrickschema2"

patrick-fs commented 5 years ago

UPDATE: I've verified that export and sync tables can be created with arbitrary database schemas (e.g. "patricktest.fsexport"). All scenarios for issue https://github.com/fullstorydev/hauser/issues/35 are proven to work in our dev Redshift database.

@butanian @sanjaybv @jameremo

patrick-fs commented 5 years ago

Hi Jess,

I did add a new config parameter called DatabaseSchema

I outlined a few usage scenarios in the issue related to this PR (https://github.com/fullstorydev/hauser/issues/35)

These changes enable our customers to satisfy best practices for schema usage: https://www.postgresql.org/docs/10/ddl-schemas.html#DDL-SCHEMAS-PATTERNS