Nasar's Blog

Tag: database

  • Qualify

    —

    by

    nasar
    in

    Snowflake QUALIFY function In a SELECT statement, the QUALIFY clause filters the results of window functions. QUALIFY does with window functions what HAVING does with aggregate functions and GROUP BY clauses. In the execution order of a query, QUALIFY is therefore evaluated after window functions are computed. QUALIFY <predicate> The QUALIFY clause simplifies queries that…

  • Importing Analytic View through BI Admin tool

    —

    by

    nasar
    in

    Opened up existing RPD and added a new database for “Oracle Analytic View” with datasource set to (description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=…. This was actually autonomous database in cloud. Did ‘Load Java data sources’ in BI Admin Tool and then ‘Import Metadata’ for this new data source. It only showed regular sql objects (tables, views etc.) and not the…