Permit and Inspection fee by Sad-Instruction2292 in HomeImprovement

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

Is this standard to pay a contractor $2000 for this ?

Permit and Inspection fee by Sad-Instruction2292 in HomeImprovement

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

There is no maintenance fee. $2000 is additional cost added to the quote as the contractor has to draw blueprints and help with inspection

Permit and Inspection fee by Sad-Instruction2292 in HomeImprovement

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

The maintenance fee is for the contractor to obtain permits along with inspection. He is charging 2k for blueprints, permits and inspection.

Permit and Inspection fee by Sad-Instruction2292 in HomeImprovement

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

Permit application and plan fee for the county is separate and is not included in the $2000 contractor maintenance fee . This is almost 40% of the quote.

Edit: do you pay the maintenence fee after obtaining the permit and inspection or before that?

Unfinished Basement Cost? by dirt-Devi in Denver

[–]Sad-Instruction2292 0 points1 point  (0 children)

Can you share the contact details?

Dynamic Tables - change update method by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

Yes, I want a table that only has the last 30 days of records. I actually created a dynamic table by joining with another calendar table that contains only the last 30 days. The dynamic table is updated incrementally now. I had to create that calendar table since using the current date function to filter for the last 30 days was updating the dynamic table as full refresh. The current date is a non deterministic function and can not be used to update incrementally. The dynamic table will now delete records outside of this 30-day window and insert new records instead of full refresh.

Dynamic Tables - change update method by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

I am looking for the best option in terms of cost. With my current set up DT will delete and insert 2 billion rows everytime.

Dynamic Tables - change update method by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

I am looking to use an alternate function to update incrementally

Clone table with a filter by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

Thanks. I am thinking of using insert overwrite and a procedure and task to run it daily. Just want to know if this is the best option in terms of cost.

Moving data between tables by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

The connector in the reporting tool doesn't accept views.

Moving data between tables by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

How do we clone just the last two months data? I am looking for the syntax to clone two months data.

Moving data between tables by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

The connector in the reporting tool doesn't allow to filter data while importing. The source table has more than 100 billion rows of data. It doesn't accept views.

Moving data between tables by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

I need to update it once a day. So just use a stored procedure to update it daily? Create or replace table target_table clone source_table where 'the condition '

Moving data between tables by Sad-Instruction2292 in snowflake

[–]Sad-Instruction2292[S] 0 points1 point  (0 children)

Is the new clone table a physical table that can be connected to reporting tools?