substitution invocator for a variable in PyCharm sql

[Mich Talebzadeh]

In Spark/Scala you can use 's' substitution invocator for a variable in sql
call, for example

    var sqltext =
      s"""
        INSERT INTO TABLE ${broadcastStagingConfig.broadcastTable}
PARTITION (broadcastId = ${broadcastStagingConfig.broadcastValue},brand)
        SELECT
          ocis_mrg_pty_id AS partyId
        , target_mobile_no AS phoneNumber
        , brand
        FROM ${tag}
       WHERE
          length(target_mobile_no) =
${broadcastStagingConfig.mobileNoLength}
       AND
          substring(target_mobile_no,1,1) =
${broadcastStagingConfig.ukMobileNoStart}
        """
    spark.sql(sqltext)

However, in PySpark the same fails

rows = spark.sql(s"""SELECT COUNT(1) FROM
${fullyQualifiedTableName}""").collect()[0][0]

   ^
SyntaxError: invalid syntax

What is the correct substitute invocation in PyCharm if any?

Thanks,



LinkedIn * 
https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*





*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.