That is more than enough

Mostly in snowflake, environments differ with database names, we can maintain all environment databases in the same snowflake account with different roles and privileges setup

More than enough

As this course was taught in Telugu this was not added to Udemy business

Watch the next set of videos, you will get the answer

Hi Sir, waiting for your reply.

Hi, however you load the data to stage table (snowpipe or copy command or manual load), the stream can capture the changes.

Thank you Sir for your response.

First we just moved the files to stage area allocated to that table, then we are loading that file data to table.

@mrjana520 thanks 🙏 anna

Video cheyyadaniki mundu nenu ppt and code(queries) prepare chesukuntanu kada. Based on requirement nenu queries rasi proper ga run ayyela chusukovali kada

Queries ekkadanunchi ravu, maname prepare chesukovali, video live lo queries type chese time vundadu kada anduke munde raaukuntamu

i am sorry sir i can't see the Description queries there thank you sooo much sir giving u r knowledge ,lots of helpfull for snowflake students thanks a lot good job sir😍

The complete playlist is already available, pls check it..

If you follow the steps as it is, it should work and check that xml file is proper and not corrupted.

name: snowflake-migration-demo # Controls when the action will run. on: push: branches: - main paths: - 'deploy/**' # Allows you to run this workflow manually from the Actions tab workflow_dispatch: jobs: deploy-snowflake-changes-job: runs-on: ubuntu-latest steps: # Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it - name: Checkout repository uses: actions/checkout@v2 - name: Use Python 3.8.x uses: actions/[email protected] with: python-version: 3.8.x - name: Run schemachange env: SF_ACCOUNT: ${{ secrets.SF_ACCOUNT }} SF_USERNAME: ${{ secrets.SF_USERNAME }} SF_ROLE: ${{ secrets.SF_ROLE }} SF_WAREHOUSE: ${{ secrets.SF_WAREHOUSE }} SF_DATABASE: ${{ secrets.SF_DATABASE }} SNOWFLAKE_PASSWORD: ${{ secrets.SF_PASSWORD }} run: | echo "GITHUB_WORKSPACE: $GITHUB_WORKSPACE" python --version echo "Step 1: Installing schemachange" pip install schemachange echo "Step 2: Running schemachange" schemachange -f $GITHUB_WORKSPACE/deploy -a $SF_ACCOUNT -u $SF_USERNAME -r $SF_ROLE -w $SF_WAREHOUSE -d $SF_DATABASE -c $SF_DATABASE.SCHEMACHANGE.CHANGE_HISTORY --create-change-history-table

Haven't worked on that yet, let me have a look into it..

Not yet

you can escape it using a backslash (\')

Watch the video External stages and understand the concept, you will get the answer.

They are public s3 buckets, you can use them directly

My Udemy Course on SQL in Telugu: www.udemy.com/course/sql-dpif/?couponCode=BE5E2344254D8D772BBD Use this coupon for Discount: BE5E2344254D8D772BBD

tell me what is your doubt.

more than enough

Will do in near future

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for 500 rupees.. I will be updating this content and will be uploading all new videos in this course. And you will have lifelong access to these videos and materials. My Snowflake Udemy Course: www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=4470941B62E9C302EA84 Use the coupon below to get a discount. Coupon: 4470941B62E9C302EA84