title: Is it possible to run a snowflake sql script without qualifying the database name.?
body: <p>Is it possible to run a SQL script without qualifying the database name?
  Currently, we are using the program like below,</p>
  
  <pre class="lang-sql prettyprint-override"><code>    SELECT  I.XXXX_LOC_SKEY,
              C.COUNTRY_SKEY
      FROM
              DEV_XXXX_DB.STAGING.XX_TABLE_LOCATION_SALES         F,
              DEV_XXXX_PRESENTATION_DB.DIMS.XXXX_LOCATIONS_D      I,
              DEV_XXXX_PRESENTATION_DB.DIMS.COUNTRY_D             C,
              DEV_XXXX_PRESENTATION_DB.DIMS.XXXX_DAILY_CALENDAR_D H
      WHERE
              F.STORE_CODE       = I.DOOR
      AND     I.CHANNEL          = 'XXXX'
      AND     F.COUNTRY          = C.COUNTRY_CODE
      AND     I.COUNTRY_SKEY     = C.COUNTRY_SKEY
      AND     F.DATE = H.DATE;
  </code></pre>
  
  <p>We would like to run the same script, without mentioning the database names as below.</p>
  
  <pre class="lang-sql prettyprint-override"><code>    SELECT  I.XXXX_LOC_SKEY,
              C.COUNTRY_SKEY
      FROM
              STAGING.XX_TABLE_LOCATION_SALES         F,
              DIMS.XXXX_LOCATIONS_D                   I,
              DIMS.COUNTRY_D                          C,
              DIMS.XXXX_DAILY_CALENDAR_D              H
      WHERE
              F.STORE_CODE       = I.DOOR
      AND     I.CHANNEL          = 'XXXX'
      AND     F.COUNTRY          = C.COUNTRY_CODE
      AND     I.COUNTRY_SKEY     = C.COUNTRY_SKEY
      AND     F.DATE = H.DATE;
  </code></pre>