And to populate the filter drop-downs you have to specify the type of field when mapping via their “x” pane as “Category” NOT “Number” or “Text” or anything else… That’s mentioned somewhere in the documentation but it’s not obvious. This whole business of brackets, for example, doesn’t play nice with table aliases so you’re almost obliged to create a well defined and indexed View in MS SQL in those sections where filters are concerned (everywhere else table aliases are probably fine). Setting up Metabase’s filter mechanism, however, is a major learning curve… Little gotchas that nobody tells you about straight off can be really painful. Best of all, all the custom do-hickies like UDFs, TVPs, CTEs, etc. Support/Metabase/Plugins/ : example directory structure for running. So if you need to create more than a single database connection in Metabase Admin > Databases, then you cannot make queries across those connections. You would need to setup a warehouse in SQL Server, BigQuery, Athena or any other supported database that supports that. Skip the “Question” building abstraction altogether, it’s of absolutely NO value when you have complex stuff already done in MS SQL. 20.0, Metabase provides a driver for connecting to Oracle databases. No, Metabase does not support queries across databases. That said you should be able to copy-paste all your custom sql queries into Metabase. So if you’re a hapless “know only enough to get by” type like myself hopefully this will save you beaucoup time and frustration! That’s one of the drawbacks w/Metabase, it’s assumed you’re a techie demi-god and know all this stuff already. Databases overview Adding and managing databases Connect to and manage your databases. Mind you it took me HOURS of researching to figure all this out. Configure the connection to Connect Cloud and click 'Save'. Navigate to the administration screen (Settings -> Admin) and click 'Add Database' from the 'Databases' tab. Use the SQL Server interface to connect to Connect Cloud. Then filling in db & instance names, leave “Windows domain” N/A, db username “sa” (sign-in as admin) and db pw (my pc’s unlocking pw)… After creating the virtual database, navigate to your Metabase instance. Adding my MS SQL db via the Metabase admin panel has been a LIFESAVER! Setting port 1433 via the Sql Server Configuration Manager per the SQL_Server_2008_R2_Express_Edition_with_Advanced_Services_ Installation_Guide_r-1-6.pdf documentation p 34, however, is apparently a requirement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |