Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Databricks Connection

    Posted Mon April 28, 2025 12:00 PM

    We're having an issue with a databricks connection in cognos 11.2.4. The connection tests successfully, but loading metadata in assets fails. It's not able to recognize the schema and tables in databricks. We were able to create a report with pass-through sql using the same connection and the report returned data so we know the jdbc connection string and credentials are valid. In order to create a data module we need to be able to pull in the metadata. We've tried with multiple databricks drivers and all are unable to pull in the metadata. Has anyone successfully pulled in assets using a databricks connection? 



    ------------------------------
    Bryan Townsend
    ------------------------------


  • 2.  RE: Databricks Connection

    Posted Tue April 29, 2025 12:05 PM
      |   view attached

    Hello Bryan,

    It seems that the table you're trying to load has more than 1000 rows. By default, Cognos limits the number of rows to 1000. However, you can adjust this limit in the load options.

    Please see the attached photo for reference.

    Thank you,
    Abbas



    ------------------------------
    Abbas Alnamar
    ------------------------------

    Original Message


  • 3.  RE: Databricks Connection

    Posted Tue April 29, 2025 12:57 PM

    I don't believe that is the issue. It doesn't appear that the data server connection is able to recognize the schema and the tables within the schema from databricks. Databricks has catalogs which contain schemas and those schemas contain the tables. We're able to see the catalogs, but not the schemas and subsequently we're unable to see the list of tables to pull in. I've attached some screenshot of what we are seeing. The error states that the schema is either empty or not accessible using the current signon. We've confirmed that the credentials are good.  



    ------------------------------
    Bryan Townsend
    ------------------------------

    Original Message


  • 4.  RE: Databricks Connection

    Posted Wed April 30, 2025 07:13 AM

    No personal experience but I found this. Try having someone create a new table.

    Unable to Load Metadata for Oracle Synonyms | Cognos Analytics



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 5.  RE: Databricks Connection
    Best Answer

    Posted 27 days ago

    We successfully resolved the issue, which stemmed from several foreign catalogs in Databricks and their associated permissions. Our Cognos connection targets a dedicated Serverless SQL Warehouse in Databricks. However, some foreign catalogs had the Browse permission granted to ALL users, which caused compatibility issues.

    When Cognos attempts to add assets from Databricks, it first tries to list all available catalogs and schemas. During this process, it encountered foreign catalogs that are not compatible with Serverless SQL Warehouses. As a result, the catalog and schema list could not be generated, preventing us from pulling in the assets.

    To fix this, we restricted access to the problematic foreign catalogs by removing the Browse permission for ALL users. This ensured that the service account used for the Cognos connection no longer had visibility into those incompatible catalogs. Once this change was made, we were able to successfully retrieve assets from Databricks as expected.



    ------------------------------
    Bryan Townsend
    ------------------------------

    Original Message


Related Content