[Lake][Test] Re-enable subscription table + create fixture + test data

[idiom-bytes]

Describe the bug
While I was debugging the data pipeline, I noticed subscription testing was hooked up but there was no data provided. This means that the testing fixture was half-implemented. For now, I have disabled subscription as part of "reducing the scope -> getting to stable -> expanding scope".

As part of stabilizing the build and keeping it stable, we need to make sure the fixture and tests are working and covering subscription functionality as expected.

Please address subscriptions properly after getting duckdb build sorted out.

DoD:

• Following along with the rest of ETL test data - Create sample data for multiple days of subscriptions..
• Hook up sample data and table to fixture
• Update fixture tests and verifications
• Make sure that gql, etl, and other subscription tests are using fixtures

Issues referencing this one

• Simplifying test coverage by removing subscriptions table - Fix Issue1076 - Scope down queries, Fix drop, Improve DRY, Stabilize e2e ETL #1077

[idiom-bytes]

Tracking remaining issues in #1299 closing this for now until we focus on solving this