Firebase Dynamic Links add random characters and are not shown in the console

Question

I'm trying to create deep links for my flutter app that go to a post preview screen for the designated post. I thought I could do this by putting the owner and post id in the URLs but I'm running into 2 issues. This is how the links should look: https://www.globemedia.me/post/owner=(owner)id=(id), but they end up looking like this: https://globemedia.me/?efr=0&ibi=flutter.globemedia.me.globeFlutter&apn=flutter.globemedia.me.globe_flutter&imv=2&amv=1&link=https%3A%2F%2Fwww.globemedia.me%2Fpost%2Fowner%3D%28(owner)%29%3Did%3D%28(id). How can I stop this from happening? If that's not possible, how can I decode this in the app when the link is opened? Another question, why would the dynamic links not show up in the Firebase console even though they are being successfully created? Here is how I'm creating the dynamic links:

    FirebaseDynamicLinks dynamicLinks = FirebaseDynamicLinks.instance;
    final DynamicLinkParameters parameters = DynamicLinkParameters(
      // The Dynamic Link URI domain. You can view created URIs on your Firebase console
      uriPrefix: 'https://globemedia.me',
      // The deep Link passed to your application which you can use to affect change
      link: Uri.parse('https://www.globemedia.me/post/owner=($owner)id=($id)'),
      // Android application details needed for opening correct app on device/Play Store
      androidParameters: const AndroidParameters(
        packageName: "flutter.globemedia.me.globe_flutter",
        minimumVersion: 1,
      ),
      // iOS application details needed for opening correct app on device/App Store
      iosParameters: const IOSParameters(
        bundleId: "flutter.globemedia.me.globeFlutter",
        minimumVersion: '2',
      ),
    );
    final Uri uri = await dynamicLinks.buildLink(parameters);

Answer 1

Unfortunately, you can't specify escape characters for external tables in Synapse SQL.

It is not supported for now.

There are 2 ways to achieve your scenario:

1. Change how files are generated from ADF

By adding quote character " you can omit the escape character from the ADF. This way serverless SQL pool will be able to read your files.

ADF configuration:

• column delimiter = comma;
• row delimiter = default; encoding = default (UTF-8);
• escape character = no escape character;
• quote character = "

2. Use OPENROWSET

This scenario can be achieved with OPENROWSET.

Here is an example of it:

SELECT *
FROM OPENROWSET(
        BULK 'path',
        FORMAT = 'CSV', 
        PARSER_VERSION = '2.0',
        FIELDTERMINATOR =',',
        ESCAPECHAR = '\\'
    ) AS [r];

You can specify escape character this way: ESCAPECHAR = '\\'

Reference in docs Query CSV files - Escape characters

You can create a new feature request and the team will triage it accordingly. Azure feedback