* Backport changes from #31355
- Skip tests because the setup depends on refactoring done in master
- See discussion: https://metaboat.slack.com/archives/C505ZNNH4/p1686648256978279

* Remove unused code

* Fix sandbox table migrations for invalid perms table (#31508)

* fix migrations and add new test

* fix migration IDs in test

* dont fail migration if FK already exists

* rewrite without table aliases to try to fix error on mysql/mariadb

* try to rewrite again

* revert to prior version of query

* another attempt at a rewrite

* fix typo

* fix typo

* bump ci

* replace LIKE with =

* fix cherry pick conflict

Co-authored-by: Ariya Hidayat <ariya@metabase.com>

* enforce download perms on dashcards

* fix tests

Co-authored-by: Noah Moss <32746338+noahmoss@users.noreply.github.com>

* fix pivot table settings crash when the question is unaggregated (#31383)

* fix pivot table settings crash when the question is unaggregated

* error boundary

* fix spec

---------

Co-authored-by: Aleksandr Lesnenko <alxnddr@users.noreply.github.com>
Co-authored-by: Aleksandr Lesnenko <alxnddr@gmail.com>

We're seeing increasing number of timeouts in CI without any significant
changes in the test suite. This could be due to GitHub's runners performance.

[ci skip]

* Move core actions E2E tests to a separate folder

* Run new `actions` E2E group in CI

Metabase actions deserve their own E2E group, as the test suite around
them is expected to grow. This commit introduces `actions` E2E group to
the CI.

Updates Snowflake driver to decode uploaded private key file data if necessary

Co-authored-by: john-metabase <92878045+john-metabase@users.noreply.github.com>

Co-authored-by: Nemanja Glumac <31325167+nemanjaglumac@users.noreply.github.com>

* Fix native source query handling for mongo

* Add test for mongo nested native query

* Fix mongo `aggregation-at-index` usage

* Add test for source query with aggregation and sort

* Adjust test for presto and oracle

* Add PR suggestions

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

Manual backport - Fix - Native editor buttons are incorrectly rendering on top of model metadata screen (#31142) (#31348)

* Manually backport #31142
- Replace createSampleDatabase with createMockDatabase
- Add missing metrics, schemas, and segments attributes in EntitiesState type
  - EntitiesState type has been heavily refactored in master and that version should be used
  - Tests will will crash without it these set in state.entities

* Fix types

* CI pre-release: Add sanity check (#31202)

* Pre-build the specific version and edition of MB (#31296)

Simply invoking `.bin/build.sh` will produce the uberjar without a
version. This is why @ariya created #30915 in the first place.

But the build script already takes `:version` and `:edition` arguments.
That is exactly what this PR is doing rather than manually unzipping the
uberjar in order to tweak its `version.properties` file.

---------

Co-authored-by: Ariya Hidayat <ariya@metabase.com>

Co-authored-by: Natalie <nat@metabase.com>

Co-authored-by: john-metabase <92878045+john-metabase@users.noreply.github.com>

Co-authored-by: Natalie <nat@metabase.com>

Co-authored-by: Denis Berezin <denis.berezin@metabase.com>

Co-authored-by: Alexander Polyankin <alexander.polyankin@metabase.com>

* Make custom `button` command chainable

* Chain `.button` directly

No need to use `.within()` anymore.
We can chain the button command directly because it now receives
the previously yielded subject.

* Fix collections bulk actions test

Manual backport - Fix - Cannot run native queries against MongoDB unless explicitly selecting the table (#31111) (#31198)

* Update 15946 e2e test
- modal() expects ModalContent to be present in DOM, but NativeQuerymodal uses ModalBody directly
- add extra check for run button to be enabled

* Add `collection` to `NativeQuery` type

* Ensure collection is present in dataset query during query conversion

* Unskip e2e test for #15946

* Handle string tableId

---------

Co-authored-by: Anton Kulyk <kuliks.anton@gmail.com>

[ci skip]

* Make E2E custom icon command chainable

* Refactor E2E helpers

We can now chain the `.icon()` command on the previous subject.

* Chain `.icon()` on prev subject in all tests

* Fix moderation-question test

* Repro #23293: Retain filter on drill-through with implicit column (#31187)

The underlying issue was fixed, but we are not sure exactly when.
This reproduction should prevent future regressions.

* Adjust the test for the release branch

---------

Co-authored-by: Nemanja Glumac <31325167+nemanjaglumac@users.noreply.github.com>

Co-authored-by: Mahatthana (Kelvin) Nomsawadi <me@bboykelvin.dev>

Co-authored-by: Natalie <nat@metabase.com>

Co-authored-by: Natalie <nat@metabase.com>

Fix not able to Enable/Disable Actions when Choose when syncs and scans happen is Enabled (#30976) (#31061)

* Fix not being able to Enable/Disable Actions when Choose when syncs and scans happen is Enabled

* Fix test

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

Manual Backport of #31102

This is because `source-field` was missing from a field dimension.

Co-authored-by: Anton Kulyk <kuliks.anton@gmail.com>

Co-authored-by: Nemanja Glumac <31325167+nemanjaglumac@users.noreply.github.com>

Co-authored-by: Noah Moss <32746338+noahmoss@users.noreply.github.com>

Co-authored-by: Natalie <nat@metabase.com>

* Add a test case for #28981

* Always open ActionParametersInputModal when clicking an action
- update unit tests to reflect this behavior

Co-authored-by: Kamil Mielnik <kamil@kamilmielnik.com>