When using a service account, the project-id isn't provided by the user,
but instead comes from the credentials for the service account. Handle
this case by looking for a project-id if one is provided explicitly,
otherwise defer to the credential object.

Additional change - during development, if (dev/init!) isn't called, the
event listeners are never setup, meaning that the initial syncs don't
occur.

Resolves #12648

[ci bigquery]

When the server (likely) requires SSL, you get an error message like:

    Caused by: com.mongodb.MongoTimeoutException: Timed out after 3000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=127.0.0.1:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketReadException: Prematurely reached end of stream}}]

When this is found, suggest that the user enable SSL.

Resolves #12605

[ci mongo]

* Repro for #12354

* Remove the qbnewb check because that's closed by default now

* Fix native -> source query perms handling

* Test fix

Co-authored-by: Cam Saul <github@camsaul.com>

* Update environment variables documentation - format similar to API docs and add EE vars [ci skip]

* Tiny fix. Thanks Martin! [ci skip]

Co-authored-by: Maz Ameli <maz@metabase.com>

* Update API docs

* Fix spelling and rerun generator

* Fix linter

* Manually changing a bad generated section

* Support substituting SQL snippets in queries

* Rename SQL snippets to native query snippets

* Add migration and model for native query snippet table

* Add API endpoints for native query snippets CRUD

Tests are incomplete. Consequently the API is not well tested.

* Cosmetic: Docstring typo and indentation

* Remove pre-delete handler that prevents deletion

It breaks in cases where deletion is reasonable, like during tests. No
DELETE API endpoint will be added, so no it shouldn't be necessary to
add any additional safeguards.

* Fix `:database_id` field reference

And remove unused import.

* Test snippets listing via API

* Add more API test stubs

* Refactor snippets listing endpoint for improved readability

* Align NativeQuerySnippet model behavior with Segment model's

* Clean ns

* Fix and test individual snippet read via API

* Fix snippet name schema

* Test creation of snippets via API

* Test update API endpoint for native query snippets

* Handle query snippet model in H2 dump/load commands

* Port load-from-h2 tests to clojure.test

* Deduplicate models list used to dump/load H2 dbs

The failing load-from-h2 test that checks that all models are accounted
for alerted me that I need to handle the new `NativeQuerySnippet` model.
However, there was no such test for dump-to-h2. Instead of adding such a
test, I opted to simply use load-from-h2's list in dump-to-h2 to
eliminate the problem, rather than testing for it.

* Dump/load collections before models that depend on it

* Linter appeasement

* Use snippet ID and content in query parameter record

* Implement snippet lookup for template tags with ID

* Basic FE support for snippet template tags

* Use shorter "snippet" prefix instead of "native-query-snippet"

* Use simpler `tru` instead of `str` with `deferred-tru`

* Allow whitespace between snippet prefix and name

Also accept any sequence of characters after prefix.

* Don't allow snippet names to start with whitespace

Whitespace is allowed between the `snippet:` template tag prefix and the
snippet name. That whitespace is trimmed out when extracting the snippet
name.

* Add database ID to snippet template tags before expanding parameters

* Ensure that snippet db matches query db

* Avoid setting `:template-tags` for native queries without it

* Factor out snippet database ID validation

* Test snippet database ID validation

* Avoid validating nil snippets

* First pass at nested template tags in snippets

* Pass parent query parameters on to nested sub-queries

* Remove unused let-binding

* Added disabled test for reading query param from template tag

* Temporarily disable failing test

* Remove half baked nested snippet support

* Snippet model perms = native query perms

* Rename param k→ks for clarity

* Remove superfluous `some?` call

* Use utility functions to reduce cruft

* Test expansion of multiple snippets in (sub-)query

* Rather use testing utils from metabase.test

* Check for snippet changes only in provided fields

* Deduplicate field checks, with added test case output

* remove unused import from bad merge

Co-authored-by: Paul Rosenzweig <paul.a.rosenzweig@gmail.com>
Co-authored-by: Paul Rosenzweig <paulrosenzweig@users.noreply.github.com>

* Support changing the language in the FE at runtime via MetabaseSettings.set("user-locale", locale). Note that some strings evaluated at load time won't be refreshed, so doing a window.location.reload() at an appropriate time is necessary

* Convert metabase.api.session-test to new style

* Support X-Metabase-Locale header

* Pass X-Metabase-Locale to /api/session/properties, update language in setup form

* Test fixes & some code cleanup

* Fix circular dependency

* Add dt DeferredTTagString

* wrap ttag rather than patching it

* refresh the UI language after updating user or site locale

* remove deferred ttag wrappers

* switch to hard refreshes, remove local from new user form

* update e2e test to use new url

* small string fixes

* add missing "?" in e2e test

* try and set default language from browser's setting

* Fix wonky merge 



Co-authored-by: Cam Saul <github@camsaul.com>
Co-authored-by: Paul Rosenzweig <paul.a.rosenzweig@gmail.com>
Co-authored-by: Maz Ameli <maz@metabase.com>

* Backported fixes

* Explicitly include data.xml as a dep

* Use OffsetDateTime instead of org.h2.api.TimestampWithTimeZone [ci mysql]

* Revert JUnit tweaks -- don't seem to be working correctly

Co-authored-by: Cam Saul <github@camsaul.com>

* Fix binning of nested questions
* Fix insight calculation

* Faster driver build strip-and-compress step by not loading Metabase core

* New cache key for FE deps

* Cache built drivers & local Maven installation of metabase-core

* Only cache the built driver JARs

* Cache built frontend

* Change driver cache key

* Try updating a specific driver [ci snowflake]

* Try updating a different driver [ci redshift] [ci snowflake]

* Need to cache driver checksums as well [ci snowflake] [ci redshift]

* Tweak what's cached for drivers (again)

Merge release 0.35.4 into master

This stops a failure during fingerprinting of a table from causing the
entire sync to fail.

Fingerprinting is now skipped for Google Analytics datasources, as they
do not support this (all queries against GA require a `metrics`
parameter)

Add an assert to ensure that `:metrics` is present in a GA query. The
Google library will fail with a NPE when it's not.

Resolves #12411

[ci googleanalytics]

This will allow the user to specify the server's certificate chain (the
public CA certs) or the server's private key if it's a self-signed cert
with no CA.

Resolves #3877

[ci mongo]

Backport master bugfixes

* Druid: don't make timestamps PKs [ci drivers]

* Fix tests [ci drivers]

* [ci drivers]

MBQL (Redshift, Vertica, Oracle): make `concat` work with any number of args